課程概述 |
2021.09.11 更新:
因應學校防疫措施,本課程(臺大資管系「資料庫管理」)開學前三週改成全線上課程,加簽申請與授權碼發放亦改為線上辦理。
若你想申請加簽或旁聽這門課,請在 2021/9/23 23:59 前至 https://pse.is/3l82gv 或 https://reurl.cc/0xokE6 填寫表單,「無須」在 2021/9/22 到教室。如果名額夠(約 100 人),授課團隊預計在 9/25 23:59 前寄發加簽資訊給所有申請人;如果名額不夠,授課團對會將作業一的繳交納入參考,預計在 9/30 23:59 前寄發加簽資訊給被選上的申請人。
詳細的課程進行方式與作業一,會在 9/21 前以影片與文件方式公告在臺大課程網與 NTU COOL。
為了因應疫情,本課程會有許多即時的授課形式的調整,不會一一更新在課程大綱上,請留意課程網站 NTU COOL 上的公告。
===
2021.08.29 更新:
110-1 的課程大綱將會在開學前公告於此。以下提供 109-1 的課程大綱,110-1 跟 109-1 會大致上相同但有一些變化:
======
Database Management Systems
Goal
The goal of the course is to develop an understanding of basic concepts and principles of database management systems.
Instructor
Anthony J.T. Lee, Dept. of Information Management
Tel: (02) 2363-0231 ext. 2978
Email: jtlee@im.ntu.edu.tw
Office hour
9~10am, Friday or by appointment
Textbook
Fundamentals of Database Systems, 3rd Edition, R. Elmasri and S.B. Navathe, Addison-Wesley(開發), 1999.
References
Database Systems, 3rd Edition, P. Rob and C. Coronel, International Thomson Publishing Company, 1997.
Database Systems, second edition, T. Connolly and C. Begg, Addison-Wesley, 1999.
Topics included
Overview
Entity-relationship model
Relational data model and relational algebra
Query language and processing
SQL
Functional dependencies and normalization
Relational database design algorithms
Transaction processing concepts
Concurrency control techniques
Recovery techniques
Distributed databases and client-server architecture
Advanced data models and emerging trends
Grading
Mid-term 30%
Final 30%
Term project 15%
Homework 25% |